Loading data unattended

You can use a scheduling tool such as Windows Task Scheduler to execute unattended scripts on iLoader.

When carrying out lengthy operations such as very large data imports through iLoader, it may sometimes be useful to carry out this operation overnight so that resources are not tied up during working hours. This is made possible by making use of iLoader Client's command line options, and a scheduling utility such as the one supplied by Microsoft with Windows.

You can start the iLoader Client from the command line by using some recognized parameters:

Allows the user to specify a particular script set with which to open iLoader Client, for example:

"C:\Program Files\Alterian\ETL\iLoaderClient\LoaderClient.exe" /s "test"

This will start the client and load the scriptset called "test".

Note:

A lower case "s" is required.

Causes the specified script to be executed, for example:

"C:\Program Files\Alterian\ETL\Loaderclient.exe" /s "test" /r

This will start the client with the script set called "test" and will execute the script set.

Note:

A lower case "r" is required.

Causes iLoader to run as an unattended execution (without showing the interface), for example:

"C:\Program Files\Alterian\ETL\Loaderclient.exe" /s "test" /r /w

This will start the client with the script set called "test" and will execute the script set without showing the interface.

Note:

A lower case "w" is required.

Causes iLoader to shutdown after running the scriptset, for example:

"C:\Program Files\Alterian\ETL\Loaderclient.exe" /s "test" /r /w /e

This will start the client with the scriptset called "test", will execute the scriptset without showing the interface, and shutdown iLoader when it has finished.

Note:

A lower case "e" is required.

By taking advantage of a scheduling tool, the /r command can be executed at any time you specify.

To do this, add a new task to the Windows Task Scheduler (it's in the Windows Control Panel).

Enter the Program/script, for example: "C:\Program Files\Alterian\ETL\iLoaderClient\LoaderClient.exe" /s "test". For this example, in the Start in field you would enter: "C:\Program Files\Alterian\ETL".

You must also supply a user name and password to allow the scheduler to perform the task as if the user had started it.

	Online & Instructor-Led Courses \| Training Videos \| Webinar Recordings
	© Alterian. All Rights Reserved. \| Privacy Policy \| Legal Notice